Instr

Instr(string1, string2)

Check for the first occurrence of one string within another string, starting from the beginning of the searched string.

All

string1 - required

The string to be searched.

string2 - required

The string to search for.

string1 is empty, "", or Null OR string2 not found.

Integer indicating the position of the start of string2 within string1 – where first character of string1 is position 1.

Note that if string 2 is empty, "", or Null, the Method also returns the value 1.

Whether or not the search is case-sensitive depends upon the setting of the Case Sensitive Script Property specified in the Project Properties. If set to True calls to Instr will be case-sensitive, if set to False they will be case-insensitive.